<?php
/**
* Created by PhpStorm.
 * User: Administrator
* Date: 2016/10/12 0012
 * Time: 下午 7:00*/
header('Content-type:text/html;charset=utf-8');
require './public_function.php';
dbInit();
$sql = 'select * form `emp_info`' ;
$emp_info = fetchAll($sql);
while ($row = mysqli_fetch_assoc($res)){
    $emp_info[]= $row;
}

define('APP','itcast');
require './list_html.php';

$where='';
if(isset($_GET['keyword'])){
    $keyword=$_GET['keyword'];
    $keyword=mysqli_real_escape_string($keyword);
    $where="where e_name like '%keyword%'";
}

$page_size=2;
$res=mysqli_query('select count(*) from `emp_info`');
$count=mysqli_fetch_row($res);
$count=$count[0];
$max_page=ceil($count/$page_size);
$page=isset($_GET['page'])?intval($_GET['page']):1;
$pge=$page>$max_page?$max_page:$page;
$page=$page<1?1:$page;



$page=1;
$page_html="<a href='./showList.php?page=1'>首页</a>&nbsp;";
$page_html="<a href='./showList.php?page=".(($page-1)>0?($page-1):1)."'>上一页</a>&nbsp;";
$page_html="<a href='./showList.php?page=".(($page+1)<$max_page?($page+1):$max_page)."'>下一页</a>&nbsp;";
$page_html="<a href='./showList.php?page={$max_page}'>尾页</a>";

$lim=($page-1)*2;
$sql="selec * from 'emp_info' limit $lim,2";
$res=mysqli_query($sql);
$emp_info=array();
while($row=mysqli_fetch_assoc($res)){
    $emp_info[]=$row;
}

$fields=array('e_dept','date_of_entry');
$sql_order='';
$order=isset($_GET['order'])?$_GET['order']:'';
$sort=isset($_GET['sort'])?$_GET['sort']:'';
if(in_array($order,$fields)) {
    if ($sort == 'desc') {
        $sql_order = "order b $order desc";
        $sort = 'asc';
    } else {
        $sql_order = "order by $order asc";
        $sort = 'desc';
    }
}

